<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<link rel="stylesheet" type="text/css" href="../css/public.css">
<title>班费信息更新</title>
</head>
<body>
<div id="maincontent">
<div id="headBlue">
<%
	String managerName = (String) session.getAttribute("managerName");
	String classId = (String) session.getAttribute("classId");
	if(managerName == null)
    	out.println("<script>alert('没有登录,请返回登录界面进行登录！');window.location='../managerLogin.html';</script>");
	//System.out.println("classId"+classId);
	Class.forName("com.mysql.jdbc.Driver").newInstance();
    Connection con = java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/classfee", "root", "1234");
    Statement stmt = con.createStatement();
    ResultSet rst = stmt.executeQuery("SELECT classFeeId FROM  tb_classFee where stuId in(select stuId from tb_student where classId='"+classId+"') order by classFeeId asc");
%>
<ul class="nopoint"><li><img src="../image/head.png" style="width:30px;height:30px"/><a id="maname" href="../tb_manager/managerupdate1.jsp" style="color:white;text-decoration: none;"><% out.println(managerName);%></a><a href="../managerlogout.jsp" style="margin-left:89%;color:white">退出登录</a></li></ul>
</div>
<div id="textArea">
<form action="classfeeupdate1.jsp" method="post">
<ul class="nopoint">
<li><label for="classFeeId">班费信息编号</label></li>
<li><select id="classFeeId" name="classFeeId"><%while(rst.next()){%><option><%out.println(rst.getInt("classFeeId")); %></option><%} %></select></li>
<li><input id="updaB" type="submit" value="修改信息">
</li>
</ul>
</form>
</div>
</div>
</body>
</html>